﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using DBA.Common;
using DBA.Data;
using DBA.Data.ADO;

namespace DBA.Bll
{
    /// <summary>
    /// 进修的业务操作类
    /// </summary>
    public class BLLEducationInfo
    {
        DataAccessLibrary dal = CommonQuery.DataAccessLibrary;
        public DataTable GetEducationInfoExcel()
        {
            //"姓名,性别,出生日期,导师,入学时间,毕业时间,毕业专业,学历,论文题目"
            StringBuffer sql = "SELECT UserName as [姓名],case when UserType = 0 then '学生' else '教师' end as [人员类别],";
            sql += "Convert(char(10),BeginTime,120) as [进修开始时间],Convert(char(10),EndTime,120) as [进修结束时间],Type as [进修类型],";
            sql += "Country as [进修国家],School as [进修学校],Demo as [备注]";
            sql += " FROM vw_EducationInfo where UserType = 0";
            return dal.ModifyData.Select(sql);

        }
    }
}
